JIRA: Select Estimate and Actually Spent (Logged) Hours

Categories: Development Notes; Tagged with: JIRA; @ May 9th, 2013 21:24

SELECT TOP 20
    CAST((ji.TIMESPENT – TIMEORIGINALESTIMATE)/3600 AS DECIMAL (6, 2)) AS [Diff(H)] ,
    CAST (ji.TIMEORIGINALESTIMATE/3600 AS DECIMAL (6,2)) AS [TIMEORIGINALESTIMATE(H)],
    CAST(ji.TIMESPENT/3600 AS DECIMAL (6, 2)) AS [TIMESPENT(H)],
    Project.pname AS [ProjectName],
    *
FROM jiraschema.jiraissue ji
    LEFT JOIN jiraschema.project Project on ji.PROJECT = PROJECT.ID
ORDER BY (ji.TIMESPENT – TIMEORIGINALESTIMATE) desc

Google I/O 2009 – The Myth of the Genius Programmer 技术大拿的传说 <-> JIRA: How to Select the user and groups mapping 获得用户与用户组关联列表